Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL
1) Aggregate Functions
2) Analytical Functions
3) Char Functions
4) Constraints
5) Conversion Functions
6) Cursor
7) Data Type
8) Date Timezone
9) Hierarchical Query
10) Index
11) Insert Delete Update
12) Large Objects
13) Numeric Math Functions
14) Object Oriented Database
15) PL SQL
16) Regular Expressions
17) Report Column Page
18) Result Set
19) Select Query
20) Sequence
21) SQL Plus
22) Stored Procedure Function
23) Subquery
24) System Packages
25) System Tables Views
26) Table
27) Table Joins
28) Trigger
29) User Previliege
30) View
31) XML

Insert Delete Update
1) Adding Multiple Rows to a Table
2) An example of using a function in the SET clause
3) Change department name to lower case
4) Change multiple rows and multiple columns in the same UPDATE statement
5) Change value case with update statement
6) Changing column order
7) Conditional INSERT Statement
8) Date calculation in insert statement
9) Delete all records in TableA whose data in field1 and field2 DO NOT match the data in fieldx and fieldz of TableB
10) Delete clause with sub query
11) Delete command with conditions
12) Delete one row
13) Delete statement with where clause and varchar2 type column
14) Including Double Quotes in a Column Value
15) Insert bulk by insert into select
16) Insert into select
17) INSERTING DATA CONTAINING APOSTROPHES
18) Inserting values using System function
19) Merge into a table
20) Modify multiple rows with a single UPDATE statement
21) Perform more complicated inserts using sub-selects
22) SELECT SPECIFIC COLUMNS
23) Specifying a Null Value for a Column
24) The order of values in the VALUES clause matches the order in which the columns are specified in the column list
25) To insert records into a table using a subquery
26) Update command without condition
27) Update data from existing column
28) Update four columns
29) Update number type column
30) Update one row
31) Update records in one table based on values in another table
32) Update salary based on average salary
33) Update the emp table, converting emp names to uppercase
34) Update with where condition
35) Use arithmetic operators and functions in the SET clause to modify data
36) Use bulk collect and rownum to insert first 10 records
37) Use quotation in insert statement in PLSQL
38) Use TO_DATE(December 31, 2002, 11
39) Use Trunc in insert statement
40) Using the column list in INSERT command, include a column list after the table name
41) WHERE clause is used to control which rows are affected by the DELETE statement
42) Without the WHERE clause, this UPDATE affects all rows in the table
43) Writing a DELETE Statement Containing a Subquery
44) Writing an UPDATE Statement Containing a Subquery
45) You can update a column and set it back to the default using the DEFAULT keyword in an UPDATE statement
46) You can use variables such as SYSDATE and USER in your INSERT statements